<?php
/*
	Copyright 2006, 2007, 2008, 2009, 2010 Bastiaan Grutters
    
    This file is part of Ages of Strife website.

    Ages of Strife website is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    Ages of Strife website is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with Ages of Strife website.  If not, see <http://www.gnu.org/licenses/>.
 */
include( "../../global/initialize.php");

if (isset ($_POST['faction_id'])) {
	$query = "SELECT count(*) " .
	"FROM faction_member " .
	"WHERE ruler_id = " . $_SESSION['ruler_id'] . " AND requested = 0 AND invited = 0";
	$result = mysql_query($query) or die("Query failed : " . mysql_error());
	$row = mysql_fetch_array($result, MYSQL_ASSOC);
	if ($row['count(*)'] > 0) {
		$status = "You are already member of a faction!";
	} else {
		$query = "SELECT count(*) " .
		"FROM faction_member " .
		"WHERE ruler_id = " . $_SESSION['ruler_id'] . " AND invited = 1 AND faction_id = '" . formatInput($_POST['faction_id']) . "'";
		$result = mysql_query($query) or die("Query failed : " . mysql_error());
		$row = mysql_fetch_array($result, MYSQL_ASSOC);
		if ($row['count(*)'] > 0) {
			$query = "DELETE FROM faction_member " .
			"WHERE ruler_id = " . $_SESSION['ruler_id'];
			mysql_query($query) or die("Query failed : " . mysql_error());

			$query = "INSERT INTO faction_member " .
			"( ruler_id, faction_id ) " .
			"VALUES( " . $_SESSION['ruler_id'] . ", '" . formatInput($_POST['faction_id']) . "' )";
			mysql_query($query) or die("Query failed : " . mysql_error());
		} else {
			$query = "SELECT count(*) " .
			"FROM faction_member " .
			"WHERE ruler_id = " . $_SESSION['ruler_id'] . " AND faction_id = '" . formatInput($_POST['faction_id']) . "' AND requested = 1";
			$result = mysql_query($query) or die("Query failed : " . mysql_error());
			$row = mysql_fetch_array($result, MYSQL_ASSOC);
			if ($row['count(*)'] > 0) {
				$query = "DELETE FROM faction_member " .
				"WHERE ruler_id = " . $_SESSION['ruler_id'] . " AND faction_id = '" . formatInput($_POST['faction_id']) . "'";
				mysql_query($query) or die("Query failed : " . mysql_error());
			} else {
				$query = "INSERT INTO faction_member " .
				"( ruler_id, faction_id, requested ) " .
				"VALUES( " . $_SESSION['ruler_id'] . ", '" . formatInput($_POST['faction_id']) . "', 1 )";
				mysql_query($query) or die("Query failed : " . mysql_error());
			}
		}
	}
} else {
	$status = "Can't request to join nothing!";
}
if (isset ($status)) {
	$_SESSION['join_faction_status'] = $status;
}
header("Location: ../diplomacy.php");
?>
